repeat

pure function repeat(n: integer): text

Repeat this text n times. SQL compatible.

Examples:

  • 'abc'.repeat(3) returns 'abcabcabc'

  • ''.repeat(3) returns ''

  • 'abc'.repeat(0) returns ''

Return

text equal to this text, except repeated n times

Since

0.11.0

Parameters

n

the number of times to repeat this text

Throws

exception

when:

  • n is negative

  • n is greater than (2^31)-1

  • the resulting text has size greater than (2^31)-1